2016-07-13 - 27613 - Spec - Material and color report #CrystalReportDevelopment

SPECIFICATIONS

27613 - Material and color report


Purpose


Need to create a datasource report which will provide ATP material and their corresponding PMS color.

Admin Info


Purpose
Need to create a datasource report which will provide atp material and their corresponding PMS color.
Requested By
Bibin Mohan
Spec Created By
Venkateswara Reddy D
Spec Created Date
07/13/2016
Spec QA by
Uday Kumar P
Objects
ZIC_ATP_Q001
Document Status
Complete

Estimates

SNo
Activity
Estimation in Hours
1
Research
10
2
Documentation
04
3
Development/ Config
16
4
Unit test in DEV
00
5
Unit test in QUA
00
6
Other activity
02

TOTAL
32

References


Prior Tickets

None

Documents

None

Spec Changes


SNo
Change Details
Requested By
Requested On
Notes if any
1
Need to add filter the data if the PMS color key is blank or #.
Saravanan Lakshmanan
07/19/2016
Filtering the data if the PMS color contains blank or # values.
2
Need to display color description in the report.
Saravanan Lakshmanan
07/19/2016
Color description added in the report.

Functional Requirement


Purpose/WHY:

Need to create datasource report which will provide ATP material and corresponding PMS color.

In Scope:

Need to create new report with output values Material and PMS color key.

Out of Scope:

None

Solution Summary


1. Need to create new datasource report with output values Material and PMS color key and description.
2. Need to filter the data if the PMS color key is # or blank values.

Test Plan
Test ID
Test Scenario
Expected Results
1
Execute Crystal Report in Crystal Designer tool after changes.
Report should execute successfully in Crystal Designer tool.
2
Schedule the Report in NEC BI Launch Pad.
Report should execute successfully in NEC BI Launch Pad.

Solution Details

1. Need to create new datasource report with output values Material and PMS color key and description.
2. Need to filter the data if the PMS color key is # or blank values.

Issues


None